Overview

Dataset info

Number of variables49
Number of observations200000
Missing cells694994 (7.1%)
Duplicate rows0 (0.0%)
Total size in memory69.3 MiB
Average record size in memory363.2 B

Variables types

Numeric13
Categorical18
Boolean15
Date0
URL0
Text (Unique)1
Rejected2
Unsupported0

Warnings

de_faixa_faturamento_estimado has 11885 (5.9%) missing values Missing
de_faixa_faturamento_estimado_grupo has 11885 (5.9%) missing values Missing
de_natureza_juridica has a high cardinality: 63 distinct values Warning
de_nivel_atividade has 4721 (2.4%) missing values Missing
de_saude_rescencia has 6356 (3.2%) missing values Missing
de_saude_tributaria has 6356 (3.2%) missing values Missing
dt_situacao has a high cardinality: 6495 distinct values Warning
empsetorcensitariofaixarendapopulacao has 62448 (31.2%) missing values Missing
fl_epp has constant value "False" Rejected
fl_optante_simei has 35727 (17.9%) missing values Missing
fl_optante_simples has 35727 (17.9%) missing values Missing
idade_media_socios has 65438 (32.7%) missing values Missing
nm_divisao has a high cardinality: 87 distinct values Warning
nm_meso_regiao has 25254 (12.6%) missing values Missing
nm_micro_regiao has a high cardinality: 74 distinct values Warning
nm_micro_regiao has 25254 (12.6%) missing values Missing
nu_meses_rescencia has 19547 (9.8%) missing values Missing
qt_filiais has 180959 (90.5%) zeros Zeros
qt_socios is highly skewed (γ1 = 26.71097273) Skewed
qt_socios has 49616 (24.8%) missing values Missing
qt_socios_feminino is highly skewed (γ1 = 56.06299548) Skewed
qt_socios_feminino has 137299 (68.6%) missing values Missing
qt_socios_masculino is highly correlated with qt_socios (ρ = 0.9711913029) Rejected
qt_socios_pj has 148477 (74.2%) zeros Zeros
qt_socios_pj has 49616 (24.8%) missing values Missing
vl_faturamento_estimado_aux is highly skewed (γ1 = 346.5212661) Skewed
vl_faturamento_estimado_aux has 11885 (5.9%) missing values Missing
vl_faturamento_estimado_grupo_aux is highly skewed (γ1 = 28.13600343) Skewed
vl_faturamento_estimado_grupo_aux has 11885 (5.9%) missing values Missing
vl_total_veiculos_leves_grupo is highly skewed (γ1 = 35.27165009) Skewed
vl_total_veiculos_leves_grupo has 183714 (91.9%) zeros Zeros
vl_total_veiculos_pesados_grupo is highly skewed (γ1 = 27.93113919) Skewed
vl_total_veiculos_pesados_grupo has 191111 (95.6%) zeros Zeros

Variables

de_faixa_faturamento_estimado
Categorical

Distinct count13
Unique (%)< 0.1%
Missing (%)5.9%
Missing (n)11885
DE R$ 81.000,01 A R$ 360.000,00
118455
ATE R$ 81.000,00
42719
DE R$ 360.000,01 A R$ 1.500.000,00
 
20014
Other values (9)
 
6927
(Missing)
 
11885
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 118455 59.2%
 
ATE R$ 81.000,00 42719 21.4%
 
DE R$ 360.000,01 A R$ 1.500.000,00 20014 10.0%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 4384 2.2%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 906 0.5%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 629 0.3%
 
SEM INFORMACAO 507 0.3%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 352 0.2%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 111 0.1%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 21 < 0.1%
 
Other values (2) 17 < 0.1%
 
(Missing) 11885 5.9%
 
Max length40
Mean length26.56831
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count12
Unique (%)< 0.1%
Missing (%)5.9%
Missing (n)11885
DE R$ 81.000,01 A R$ 360.000,00
109328
ATE R$ 81.000,00
42512
DE R$ 360.000,01 A R$ 1.500.000,00
23065
Other values (8)
 
13210
(Missing)
 
11885
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 109328 54.7%
 
ATE R$ 81.000,00 42512 21.3%
 
DE R$ 360.000,01 A R$ 1.500.000,00 23065 11.5%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 5858 2.9%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 1768 0.9%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 1622 0.8%
 
ACIMA DE 1 BILHAO DE REAIS 1507 0.8%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 1272 0.6%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 660 0.3%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 291 0.1%
 
(Missing) 11885 5.9%
 
Max length40
Mean length26.816375
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_natureza_juridica
Categorical

Distinct count63
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
127984
SOCIEDADE EMPRESARIA LIMITADA
39432
ASSOCIACAO PRIVADA
 
12883
Other values (60)
 
19701
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 127984 64.0%
 
SOCIEDADE EMPRESARIA LIMITADA 39432 19.7%
 
ASSOCIACAO PRIVADA 12883 6.4%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 6560 3.3%
 
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO 3129 1.6%
 
ORGANIZACAO RELIGIOSA 1275 0.6%
 
SOCIEDADE ANONIMA FECHADA 949 0.5%
 
CONDOMINIO EDILICIO 887 0.4%
 
ENTIDADE SINDICAL 770 0.4%
 
CANDIDATO A CARGO POLITICO ELETIVO 693 0.3%
 
Other values (53) 5438 2.7%
 
Max length70
Mean length24.489855
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)2.4%
Missing (n)4721
MEDIA
94617
ALTA
65726
BAIXA
32889
(Missing)
 
4721
ValueCountFrequency (%) 
MEDIA 94617 47.3%
 
ALTA 65726 32.9%
 
BAIXA 32889 16.4%
 
MUITO BAIXA 2047 1.0%
 
(Missing) 4721 2.4%
 
Max length11
Mean length4.68557
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count33
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
74773
SERVICOS DIVERSOS
26040
SERVICOS DE ALOJAMENTO/ALIMENTACAO
 
13022
Other values (30)
86165
ValueCountFrequency (%) 
COMERCIO VAREJISTA 74773 37.4%
 
SERVICOS DIVERSOS 26040 13.0%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 13022 6.5%
 
INDUSTRIA DA CONSTRUCAO 11037 5.5%
 
COMERCIO E REPARACAO DE VEICULOS 9633 4.8%
 
BENS DE CONSUMO 9311 4.7%
 
SERVICOS ADMINISTRATIVOS 9216 4.6%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 7452 3.7%
 
COMERCIO POR ATACADO 7092 3.5%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 6618 3.3%
 
Other values (23) 25806 12.9%
 
Max length49
Mean length22.054005
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)3.2%
Missing (n)6356
ACIMA DE 1 ANO
163960
ATE 1 ANO
 
16486
SEM INFORMACAO
 
13191
Other values (2)
 
7
(Missing)
 
6356
ValueCountFrequency (%) 
ACIMA DE 1 ANO 163960 82.0%
 
ATE 1 ANO 16486 8.2%
 
SEM INFORMACAO 13191 6.6%
 
ATE 3 MESES 6 < 0.1%
 
ATE 6 MESES 1 < 0.1%
 
(Missing) 6356 3.2%
 
Max length14
Mean length13.238165
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)3.2%
Missing (n)6356
VERDE
62976
AZUL
45670
AMARELO
39297
Other values (3)
45701
ValueCountFrequency (%) 
VERDE 62976 31.5%
 
AZUL 45670 22.8%
 
AMARELO 39297 19.6%
 
CINZA 27688 13.8%
 
LARANJA 15616 7.8%
 
VERMELHO 2397 1.2%
 
(Missing) 6356 3.2%
 
Max length8
Mean length5.293175
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count6495
Unique (%)3.2%
Missing (%)< 0.1%
Missing (n)2
2005-11-03
 
30087
2006-12-21
 
967
2006-12-01
 
891
Other values (6491)
168053
ValueCountFrequency (%) 
2005-11-03 30087 15.0%
 
2006-12-21 967 0.5%
 
2006-12-01 891 0.4%
 
2010-05-15 771 0.4%
 
2005-09-24 679 0.3%
 
2006-12-02 645 0.3%
 
1998-07-28 644 0.3%
 
2005-08-27 584 0.3%
 
2004-10-30 408 0.2%
 
2001-07-01 390 0.2%
 
Other values (6484) 163932 82.0%
 
Max length10
Mean length9.99993
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count14072
Unique (%)7.0%
Missing (%)31.2%
Missing (n)62448
Infinite (%)0.0%
Infinite (n)0
Mean1302.532581
Minimum100
Maximum75093.84
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum100
5-th percentile424.291
Q1670.68
Median944.94
Q31511.81
95-th percentile3516.495
Maximum75093.84
Range74993.84
Interquartile range841.13

Descriptive statistics

Standard deviation1147.151209
Coef of variation0.8807082641
Kurtosis409.4083295
Mean1302.532581
MAD715.9528233
Skewness9.22983695
Sum179165961.7
Variance1315955.896
Memory size3.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1549.1 864 0.4%
 
2361.38 363 0.2%
 
1086.05 317 0.2%
 
3940.05 241 0.1%
 
786.74 211 0.1%
 
3321.86 206 0.1%
 
2679.5 198 0.1%
 
2019.39 196 0.1%
 
1692.92 194 0.1%
 
1910.81 191 0.1%
 
Other values (14061) 134571 67.3%
 
(Missing) 62448 31.2%
 

Minimum 5 values

ValueCountFrequency (%) 
100 2 < 0.1%
 
110.3 24 < 0.1%
 
151.35 1 < 0.1%
 
169.28 18 < 0.1%
 
172.68 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
75093.84 3 < 0.1%
 
30861.81 8 < 0.1%
 
13793 10 < 0.1%
 
12512.93 51 < 0.1%
 
11281.03 2 < 0.1%
 

fl_antt
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
False
197819
True
 
1389
(Missing)
 
792
ValueCountFrequency (%) 
False 197819 98.9%
 
True 1389 0.7%
 
(Missing) 792 0.4%
 

fl_email
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
110674
True
89326
ValueCountFrequency (%) 
False 110674 55.3%
 
True 89326 44.7%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
199478
True
 
522
ValueCountFrequency (%) 
False 199478 99.7%
 
True 522 0.3%
 

fl_matriz
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
True
187468
False
 
12532
ValueCountFrequency (%) 
True 187468 93.7%
 
False 12532 6.3%
 

fl_me
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
199515
True
 
485
ValueCountFrequency (%) 
False 199515 99.8%
 
True 485 0.2%
 

fl_mei
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
134640
True
65360
ValueCountFrequency (%) 
False 134640 67.3%
 
True 65360 32.7%
 

fl_optante_simei
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)17.9%
Missing (n)35727
False
123510
True
40763
(Missing)
35727
ValueCountFrequency (%) 
False 123510 61.8%
 
True 40763 20.4%
 
(Missing) 35727 17.9%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)17.9%
Missing (n)35727
True
86493
False
77780
(Missing)
35727
ValueCountFrequency (%) 
True 86493 43.2%
 
False 77780 38.9%
 
(Missing) 35727 17.9%
 

fl_passivel_iss
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
True
114393
False
84815
(Missing)
 
792
ValueCountFrequency (%) 
True 114393 57.2%
 
False 84815 42.4%
 
(Missing) 792 0.4%
 

fl_rm
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
NAO
102598
SIM
97402
ValueCountFrequency (%) 
NAO 102598 51.3%
 
SIM 97402 48.7%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
196383
True
 
3617
ValueCountFrequency (%) 
False 196383 98.2%
 
True 3617 1.8%
 

fl_simples_irregular
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
False
199046
True
 
162
(Missing)
 
792
ValueCountFrequency (%) 
False 199046 99.5%
 
True 162 0.1%
 
(Missing) 792 0.4%
 

fl_spa
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
False
199109
True
 
99
(Missing)
 
792
ValueCountFrequency (%) 
False 199109 99.6%
 
True 99 < 0.1%
 
(Missing) 792 0.4%
 

fl_st_especial
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
199967
True
 
33
ValueCountFrequency (%) 
False 199967 > 99.9%
 
True 33 < 0.1%
 

fl_telefone
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
True
145216
False
54784
ValueCountFrequency (%) 
True 145216 72.6%
 
False 54784 27.4%
 

fl_veiculo
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
False
186018
True
 
13190
(Missing)
 
792
ValueCountFrequency (%) 
False 186018 93.0%
 
True 13190 6.6%
 
(Missing) 792 0.4%
 

id
Categorical, Unique

First 5 values
000001857eec66f7d67ea918825c9980eebff5c10b36f3...
0000133f443484b40bc632e3b8595c8348441b3899973f...
000061121bf1a98d79c02f156af0cadec80ea1c68236e6...
0000bf5a53db23cf7ccbe510f95c423b97f9604546d584...
00018b2dbaacca029e4714f0f85bc86c41a4b4a3df8fcb...
Last 5 values
fffebe9316b77dc030834bdecf643e2f1d8d912a79bc45...
ffff04db2ba37d91b738fdac887d5744018d10c4d5504f...
ffff191aa04c113dcc5c71dbf04bebfb43ed03fe4f20fb...
ffff27cb2ef65222f5e6563ec7a1f0418610bdfef1f5cd...
ffff3005ff89346b011e6d35e35983e42a0bb5a2262d45...

First 5 values

ValueCountFrequency (%) 
000001857eec66f7d67ea918825c9980eebff5c10b36f3cbcf8b977dae2673f3 1 < 0.1%
 
0000133f443484b40bc632e3b8595c8348441b3899973f25a5375e915f84ef88 1 < 0.1%
 
000061121bf1a98d79c02f156af0cadec80ea1c68236e69c8a36d0b087878a78 1 < 0.1%
 
0000bf5a53db23cf7ccbe510f95c423b97f9604546d584b33b0054a411cf9429 1 < 0.1%
 
00018b2dbaacca029e4714f0f85bc86c41a4b4a3df8fcb4f459b464fb1a40e56 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
ffff3005ff89346b011e6d35e35983e42a0bb5a2262d45acb7af4baee64b373a 1 < 0.1%
 
ffff27cb2ef65222f5e6563ec7a1f0418610bdfef1f5cd14692ec66879869148 1 < 0.1%
 
ffff191aa04c113dcc5c71dbf04bebfb43ed03fe4f20fb5970129e9de77542ad 1 < 0.1%
 
ffff04db2ba37d91b738fdac887d5744018d10c4d5504ffdfe1e2a5a192b236c 1 < 0.1%
 
fffebe9316b77dc030834bdecf643e2f1d8d912a79bc45ff69ff1b509fae1126 1 < 0.1%
 

idade_emp_cat
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1 a 5
59888
5 a 10
50244
> 20
32651
Other values (3)
57217
ValueCountFrequency (%) 
1 a 5 59888 29.9%
 
5 a 10 50244 25.1%
 
> 20 32651 16.3%
 
10 a 15 21391 10.7%
 
<= 1 20213 10.1%
 
15 a 20 15613 7.8%
 
Max length7
Mean length5.35694
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count12625
Unique (%)6.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.947989959
Minimum0.01643835616
Maximum89.44383562
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.01643835616
5-th percentile0.4657534247
Q12.767123288
Median6.704109589
Q314.45753425
95-th percentile30.15616438
Maximum89.44383562
Range89.42739726
Interquartile range11.69041096

Descriptive statistics

Standard deviation9.607973303
Coef of variation0.965820567
Kurtosis1.500814832
Mean9.947989959
MAD7.548775603
Skewness1.373912367
Sum1989597.992
Variance92.31315099
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.64383562e-02 2.87671233e-02 3.69863014e-02 4.52054795e-02 5.61643836e-02 ... 4.89684932e+01 5.20698630e+01 5.22917808e+01 5.67438356e+01 8.94438356e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.2054794521 261 0.1%
 
0.2082191781 244 0.1%
 
0.202739726 199 0.1%
 
0.2164383562 140 0.1%
 
7.331506849 128 0.1%
 
8.021917808 123 0.1%
 
0.2438356164 120 0.1%
 
0.2 119 0.1%
 
7.334246575 116 0.1%
 
0.7452054795 114 0.1%
 
Other values (12615) 198436 99.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0.01643835616 1 < 0.1%
 
0.02739726027 11 < 0.1%
 
0.0301369863 72 < 0.1%
 
0.03287671233 85 < 0.1%
 
0.03561643836 70 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
89.44383562 1 < 0.1%
 
74.87123288 1 < 0.1%
 
72.43013699 1 < 0.1%
 
67.90136986 1 < 0.1%
 
63.71506849 1 < 0.1%
 

idade_media_socios
Numeric

Distinct count764
Unique (%)0.4%
Missing (%)32.7%
Missing (n)65438
Infinite (%)0.0%
Infinite (n)0
Mean42.81210697
Minimum4
Maximum127
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile24
Q133
Median42
Q351
95-th percentile65
Maximum127
Range123
Interquartile range18

Descriptive statistics

Standard deviation12.64238542
Coef of variation0.2952993047
Kurtosis0.1020027824
Mean42.81210697
MAD10.24207012
Skewness0.5041636159
Sum5760882.739
Variance159.8299092
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
37 3757 1.9%
 
36 3748 1.9%
 
38 3604 1.8%
 
35 3562 1.8%
 
39 3515 1.8%
 
34 3510 1.8%
 
41 3496 1.7%
 
40 3489 1.7%
 
33 3489 1.7%
 
32 3370 1.7%
 
Other values (753) 99022 49.5%
 
(Missing) 65438 32.7%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 < 0.1%
 
5 1 < 0.1%
 
6 3 < 0.1%
 
7 2 < 0.1%
 
7.5 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
127 1 < 0.1%
 
121 1 < 0.1%
 
117 1 < 0.1%
 
110 2 < 0.1%
 
108 2 < 0.1%
 

natureza_juridica_macro
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
OUTROS
138512
ENTIDADES EMPRESARIAIS
42874
ENTIDADES SEM FINS LUCRATIVOS
 
16088
Other values (4)
 
2526
ValueCountFrequency (%) 
OUTROS 138512 69.3%
 
ENTIDADES EMPRESARIAIS 42874 21.4%
 
ENTIDADES SEM FINS LUCRATIVOS 16088 8.0%
 
ADMINISTRACAO PUBLICA 1305 0.7%
 
CARGO POLITICO 693 0.3%
 
PESSOAS FISICAS 527 0.3%
 
INSTITUICOES EXTRATERRITORIAIS 1 < 0.1%
 
Max length30
Mean length11.42947
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count87
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
COMERCIO VAREJISTA
74773
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS
 
16475
ALIMENTACAO
 
11876
Other values (83)
96084
ValueCountFrequency (%) 
COMERCIO VAREJISTA 74773 37.4%
 
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS 16475 8.2%
 
ALIMENTACAO 11876 5.9%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 9633 4.8%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 7092 3.5%
 
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS 6783 3.4%
 
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO 6137 3.1%
 
TRANSPORTE TERRESTRE 4884 2.4%
 
EDUCACAO 4851 2.4%
 
CONSTRUCAO DE EDIFICIOS 4249 2.1%
 
Other values (76) 52455 26.2%
 
Max length120
Mean length32.88121
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)< 0.1%
Missing (%)12.6%
Missing (n)25254
CENTRO AMAZONENSE
30864
NORTE MARANHENSE
26524
LESTE POTIGUAR
25571
Other values (16)
91787
(Missing)
25254
ValueCountFrequency (%) 
CENTRO AMAZONENSE 30864 15.4%
 
NORTE MARANHENSE 26524 13.3%
 
LESTE POTIGUAR 25571 12.8%
 
CENTRO NORTE PIAUIENSE 18283 9.1%
 
OESTE MARANHENSE 11590 5.8%
 
OESTE POTIGUAR 9076 4.5%
 
LESTE MARANHENSE 7588 3.8%
 
VALE DO ACRE 7181 3.6%
 
CENTRO MARANHENSE 6027 3.0%
 
SUDOESTE PIAUIENSE 5258 2.6%
 
Other values (9) 26784 13.4%
 
(Missing) 25254 12.6%
 
Max length22
Mean length14.59602
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count74
Unique (%)< 0.1%
Missing (%)12.6%
Missing (n)25254
MANAUS
25887
NATAL
 
20273
AGLOMERACAO URBANA DE SAO LUIS
 
19833
Other values (70)
108753
(Missing)
25254
ValueCountFrequency (%) 
MANAUS 25887 12.9%
 
NATAL 20273 10.1%
 
AGLOMERACAO URBANA DE SAO LUIS 19833 9.9%
 
TERESINA 14630 7.3%
 
IMPERATRIZ 6829 3.4%
 
RIO BRANCO 6111 3.1%
 
MOSSORO 4646 2.3%
 
PINDARE 3619 1.8%
 
MACAIBA 3213 1.6%
 
LITORAL PIAUIENSE 2958 1.5%
 
Other values (63) 66747 33.4%
 
(Missing) 25254 12.6%
 
Max length33
Mean length11.095095
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count22
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
91498
OUTRAS ATIVIDADES DE SERVICOS
25709
INDUSTRIAS DE TRANSFORMACAO
 
13897
Other values (18)
68104
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 91498 45.7%
 
OUTRAS ATIVIDADES DE SERVICOS 25709 12.9%
 
INDUSTRIAS DE TRANSFORMACAO 13897 6.9%
 
ALOJAMENTO E ALIMENTACAO 13022 6.5%
 
CONSTRUCAO 11037 5.5%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 9216 4.6%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 7452 3.7%
 
TRANSPORTE ARMAZENAGEM E CORREIO 6618 3.3%
 
EDUCACAO 4851 2.4%
 
SAUDE HUMANA E SERVICOS SOCIAIS 4423 2.2%
 
Other values (11) 11485 5.7%
 
Max length65
Mean length42.540665
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count51
Unique (%)< 0.1%
Missing (%)9.8%
Missing (n)19547
Infinite (%)0.0%
Infinite (n)0
Mean24.99726245
Minimum0
Maximum66
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum66
Range66
Interquartile range3

Descriptive statistics

Standard deviation9.674244591
Coef of variation0.3870121623
Kurtosis1.961121154
Mean24.99726245
MAD5.873673916
Skewness1.26387979
Sum4510831
Variance93.5910084
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
23 47070 23.5%
 
22 38641 19.3%
 
24 19297 9.6%
 
48 11375 5.7%
 
25 10805 5.4%
 
26 10475 5.2%
 
27 8130 4.1%
 
21 5283 2.6%
 
7 4371 2.2%
 
47 4218 2.1%
 
Other values (40) 20788 10.4%
 
(Missing) 19547 9.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 2 < 0.1%
 
2 3 < 0.1%
 
5 1 < 0.1%
 
7 4371 2.2%
 

Maximum 5 values

ValueCountFrequency (%) 
66 18 < 0.1%
 
65 17 < 0.1%
 
64 3 < 0.1%
 
54 679 0.3%
 
53 14 < 0.1%
 

qt_filiais
Numeric

Distinct count277
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean27.51195
Minimum0
Maximum9647
Zeros (%)90.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum9647
Range9647
Interquartile range0

Descriptive statistics

Standard deviation459.1047766
Coef of variation16.68746768
Kurtosis374.733309
Mean27.51195
MAD53.66682345
Skewness19.13128244
Sum5502390
Variance210777.1959
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 5.2110e+03 5.4670e+03 8.4785e+03 9.3405e+03 9.6470e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 180959 90.5%
 
1 8441 4.2%
 
2 2549 1.3%
 
3 1238 0.6%
 
4 783 0.4%
 
5 489 0.2%
 
6 343 0.2%
 
7 294 0.1%
 
8 232 0.1%
 
10 213 0.1%
 
Other values (267) 4459 2.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 180959 90.5%
 
1 8441 4.2%
 
2 2549 1.3%
 
3 1238 0.6%
 
4 783 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
9647 105 0.1%
 
9411 123 0.1%
 
9270 164 0.1%
 
7687 65 < 0.1%
 
5491 39 < 0.1%
 

qt_socios
Numeric

Distinct count47
Unique (%)< 0.1%
Missing (%)24.8%
Missing (n)49616
Infinite (%)0.0%
Infinite (n)0
Mean1.484765667
Minimum1
Maximum153
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile3
Maximum153
Range152
Interquartile range1

Descriptive statistics

Standard deviation3.124724546
Coef of variation2.104523708
Kurtosis825.9712659
Mean1.484765667
MAD0.72188127
Skewness26.71097273
Sum223285
Variance9.763903487
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%) 
1 111971 56.0%
 
2 30747 15.4%
 
3 3831 1.9%
 
4 1395 0.7%
 
5 717 0.4%
 
6 420 0.2%
 
8 317 0.2%
 
7 263 0.1%
 
9 118 0.1%
 
96 105 0.1%
 
Other values (36) 500 0.2%
 
(Missing) 49616 24.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 111971 56.0%
 
2 30747 15.4%
 
3 3831 1.9%
 
4 1395 0.7%
 
5 717 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
153 1 < 0.1%
 
142 1 < 0.1%
 
139 1 < 0.1%
 
109 15 < 0.1%
 
96 105 0.1%
 

qt_socios_feminino
Numeric

Distinct count23
Unique (%)< 0.1%
Missing (%)68.6%
Missing (n)137299
Infinite (%)0.0%
Infinite (n)0
Mean1.107079632
Minimum1
Maximum93
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum93
Range92
Interquartile range0

Descriptive statistics

Standard deviation0.6837725746
Coef of variation0.6176363063
Kurtosis6196.851084
Mean1.107079632
MAD0.1977304021
Skewness56.06299548
Sum69415
Variance0.4675449338
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%) 
1 57891 28.9%
 
2 3974 2.0%
 
3 533 0.3%
 
4 148 0.1%
 
5 63 < 0.1%
 
6 25 < 0.1%
 
15 16 < 0.1%
 
9 12 < 0.1%
 
7 11 < 0.1%
 
8 10 < 0.1%
 
Other values (12) 18 < 0.1%
 
(Missing) 137299 68.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 57891 28.9%
 
2 3974 2.0%
 
3 533 0.3%
 
4 148 0.1%
 
5 63 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
93 1 < 0.1%
 
59 1 < 0.1%
 
25 2 < 0.1%
 
24 1 < 0.1%
 
22 2 < 0.1%
 

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.9711913029

qt_socios_pj
Numeric

Distinct count13
Unique (%)< 0.1%
Missing (%)24.8%
Missing (n)49616
Infinite (%)0.0%
Infinite (n)0
Mean0.01907117778
Minimum0
Maximum13
Zeros (%)74.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum13
Range13
Interquartile range0

Descriptive statistics

Standard deviation0.1943337274
Coef of variation10.18991745
Kurtosis480.7900332
Mean0.01907117778
MAD0.03765867731
Skewness16.26400576
Sum2868
Variance0.03776559759
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%) 
0 148477 74.2%
 
1 1173 0.6%
 
2 602 0.3%
 
3 86 < 0.1%
 
4 31 < 0.1%
 
5 5 < 0.1%
 
7 3 < 0.1%
 
6 2 < 0.1%
 
9 2 < 0.1%
 
13 1 < 0.1%
 
Other values (2) 2 < 0.1%
 
(Missing) 49616 24.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 148477 74.2%
 
1 1173 0.6%
 
2 602 0.3%
 
3 86 < 0.1%
 
4 31 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13 1 < 0.1%
 
12 1 < 0.1%
 
9 2 < 0.1%
 
8 1 < 0.1%
 
7 3 < 0.1%
 

setor
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)792
COMERCIO
91498
SERVIÇO
81829
INDUSTRIA
 
13424
Other values (2)
 
12457
ValueCountFrequency (%) 
COMERCIO 91498 45.7%
 
SERVIÇO 81829 40.9%
 
INDUSTRIA 13424 6.7%
 
CONSTRUÇÃO CIVIL 11037 5.5%
 
AGROPECUARIA 1420 0.7%
 
(Missing) 792 0.4%
 
Max length16
Mean length8.108055
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
MA
55257
RN
42877
AM
35370
Other values (3)
66496
ValueCountFrequency (%) 
MA 55257 27.6%
 
RN 42877 21.4%
 
AM 35370 17.7%
 
PI 33279 16.6%
 
RO 24317 12.2%
 
AC 8900 4.5%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count28
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)795
MA
54056
RN
42015
AM
34489
Other values (24)
68645
ValueCountFrequency (%) 
MA 54056 27.0%
 
RN 42015 21.0%
 
AM 34489 17.2%
 
PI 32628 16.3%
 
RO 23662 11.8%
 
AC 8651 4.3%
 
SP 1258 0.6%
 
DF 505 0.3%
 
CE 404 0.2%
 
RJ 276 0.1%
 
Other values (17) 1261 0.6%
 
(Missing) 795 0.4%
 
Max length3
Mean length2.003975
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Unnamed_0.1
Numeric

Distinct count200000
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean99999.5
Minimum0
Maximum199999
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile9999.95
Q149999.75
Median99999.5
Q3149999.25
95-th percentile189999.05
Maximum199999
Range199999
Interquartile range99999.5

Descriptive statistics

Standard deviation57735.17126
Coef of variation0.5773545993
Kurtosis-1.2
Mean99999.5
MAD50000
Skewness0
Sum1.99999e+10
Variance3333350000
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 199999.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
152928 1 < 0.1%
 
189814 1 < 0.1%
 
195957 1 < 0.1%
 
193908 1 < 0.1%
 
183667 1 < 0.1%
 
181618 1 < 0.1%
 
187761 1 < 0.1%
 
185712 1 < 0.1%
 
142703 1 < 0.1%
 
Other values (199990) 199990 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
199999 1 < 0.1%
 
199998 1 < 0.1%
 
199997 1 < 0.1%
 
199996 1 < 0.1%
 
199995 1 < 0.1%
 

vl_faturamento_estimado_aux
Numeric

Distinct count1225
Unique (%)0.6%
Missing (%)5.9%
Missing (n)11885
Infinite (%)0.0%
Infinite (n)0
Mean789491.3819
Minimum0
Maximum1.4546625e+10
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile50000
Q1164851.2
Median210000
Q3210000
95-th percentile947894.4
Maximum1.4546625e+10
Range1.4546625e+10
Interquartile range45148.8

Descriptive statistics

Standard deviation36398055.47
Coef of variation46.1031701
Kurtosis136074.6802
Mean789491.3819
MAD1096986.45
Skewness346.5212661
Sum1.485151713e+11
Variance1.324818442e+15
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 108120 54.1%
 
50000 40784 20.4%
 
930000 7060 3.5%
 
185457.6 3570 1.8%
 
370915.2 2796 1.4%
 
123638.4 2720 1.4%
 
247276.8 1675 0.8%
 
556372.8 1282 0.6%
 
741830.4 1220 0.6%
 
61819.2 943 0.5%
 
Other values (1214) 17945 9.0%
 
(Missing) 11885 5.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 507 0.3%
 
41212.8 849 0.4%
 
50000 40784 20.4%
 
51516 143 0.1%
 
61819.2 943 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
1.4546625e+10 1 < 0.1%
 
3220831700 1 < 0.1%
 
2068779500 1 < 0.1%
 
2048888000 1 < 0.1%
 
1489842700 1 < 0.1%
 

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count4416
Unique (%)2.2%
Missing (%)5.9%
Missing (n)11885
Infinite (%)0.0%
Infinite (n)0
Mean306243925.2
Minimum41212.8
Maximum2.227618e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum41212.8
5-th percentile50000
Q1185457.6
Median210000
Q3210000
95-th percentile2827058.91
Maximum2.227618e+11
Range2.227617588e+11
Interquartile range24542.4

Descriptive statistics

Standard deviation6677856568
Coef of variation21.80567848
Kurtosis837.9308527
Mean306243925.2
MAD602867603.8
Skewness28.13600343
Sum5.760907598e+13
Variance4.459376835e+19
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 99930 50.0%
 
50000 40784 20.4%
 
930000 5612 2.8%
 
185457.6 3111 1.6%
 
420000 2999 1.5%
 
123638.4 2450 1.2%
 
370915.2 2387 1.2%
 
247276.8 1455 0.7%
 
556372.8 1075 0.5%
 
741830.4 1028 0.5%
 
Other values (4405) 27284 13.6%
 
(Missing) 11885 5.9%
 

Minimum 5 values

ValueCountFrequency (%) 
41212.8 773 0.4%
 
50000 40784 20.4%
 
51516 135 0.1%
 
61819.2 820 0.4%
 
82425.6 257 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.227618e+11 65 < 0.1%
 
1.8943014e+11 105 0.1%
 
1.8120853e+11 15 < 0.1%
 
1.2398112e+11 4 < 0.1%
 
1.009873e+11 8 < 0.1%
 

vl_total_veiculos_leves_grupo
Numeric

Distinct count250
Unique (%)0.1%
Missing (%)0.4%
Missing (n)792
Infinite (%)0.0%
Infinite (n)0
Mean48.27108349
Minimum0
Maximum122090
Zeros (%)91.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum122090
Range122090
Interquartile range0

Descriptive statistics

Standard deviation1212.466738
Coef of variation25.11786872
Kurtosis1708.785325
Mean48.27108349
MAD95.14304612
Skewness35.27165009
Sum9615986
Variance1470075.591
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 183714 91.9%
 
1 6793 3.4%
 
2 2247 1.1%
 
3 1111 0.6%
 
4 670 0.3%
 
5 460 0.2%
 
6 333 0.2%
 
7 269 0.1%
 
8 231 0.1%
 
10 176 0.1%
 
Other values (239) 3204 1.6%
 
(Missing) 792 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 183714 91.9%
 
1 6793 3.4%
 
2 2247 1.1%
 
3 1111 0.6%
 
4 670 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
122090 1 < 0.1%
 
105312 1 < 0.1%
 
96763 1 < 0.1%
 
44229 1 < 0.1%
 
44175 1 < 0.1%
 

vl_total_veiculos_pesados_grupo
Numeric

Distinct count228
Unique (%)0.1%
Missing (%)0.4%
Missing (n)792
Infinite (%)0.0%
Infinite (n)0
Mean3.454509859
Minimum0
Maximum3674
Zeros (%)95.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum3674
Range3674
Interquartile range0

Descriptive statistics

Standard deviation69.53233698
Coef of variation20.12798916
Kurtosis868.4489056
Mean3.454509859
MAD6.71861698
Skewness27.93113919
Sum688166
Variance4834.745886
Memory size8.1 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 191111 95.6%
 
1 2913 1.5%
 
2 1105 0.6%
 
3 548 0.3%
 
4 378 0.2%
 
5 278 0.1%
 
7 230 0.1%
 
6 198 0.1%
 
1177 164 0.1%
 
8 128 0.1%
 
Other values (217) 2155 1.1%
 
(Missing) 792 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 191111 95.6%
 
1 2913 1.5%
 
2 1105 0.6%
 
3 548 0.3%
 
4 378 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
3674 1 < 0.1%
 
2710 1 < 0.1%
 
2693 4 < 0.1%
 
2347 105 0.1%
 
2151 1 < 0.1%
 

Correlations

Missing values

Sample

First rows

de_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculoididade_emp_catidade_empresa_anosidade_media_sociosnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciaqt_filiaisqt_sociosqt_socios_femininoqt_socios_masculinoqt_socios_pjsetorsg_ufsg_uf_matrizUnnamed_0.1vl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_total_veiculos_leves_grupovl_total_veiculos_pesados_grupo
0DE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 1.500.000,01 A R$ 4.800.000,00SOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-03-25NaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalsea6984c3ae395090e3bee8ad63c3758b110de096d5d8195...10 a 1514.45753444.0ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSLESTE POTIGUARNATALCONSTRUCAO23.002.0NaN2.00.0CONSTRUÇÃO CIVILRNRN03132172.83132172.80.00.0
1DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOATE 1 ANOCINZA2017-05-12468.93FalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalse6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...1 a 51.46301427.0OUTROSALIMENTACAOCENTRO NORTE PIAUIENSETERESINAALOJAMENTO E ALIMENTACAO9.001.0NaN1.00.0SERVIÇOPIPI1210000.0210000.00.00.0
2ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-09-26713.50FalseFalseFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalse4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...5 a 107.09315132.0OUTROSTRANSPORTE TERRESTRECENTRO AMAZONENSEMANAUSTRANSPORTE ARMAZENAGEM E CORREIO26.001.0NaN1.00.0SERVIÇOAMAM250000.050000.00.00.0
3DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMEDIASERVICOS DIVERSOSACIMA DE 1 ANOAMARELO2012-04-25475.73FalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalse3348900fe63216a439d2e5238c79ddd46ede454df7b9d8...5 a 106.51232936.0OUTROSREPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...CENTRO AMAZONENSEMANAUSOUTRAS ATIVIDADES DE SERVICOS26.001.0NaN1.00.0SERVIÇOAMAM3210000.0210000.00.00.0
4DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2015-08-172874.04FalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalse1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...1 a 53.200000NaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...LESTE POTIGUARNATALATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS27.001.0NaNNaN0.0SERVIÇORNRN4210000.0210000.00.00.0
5DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00SOCIEDADE EMPRESARIA LIMITADAALTAQUIMICA-PETROQUIMICAACIMA DE 1 ANOLARANJA2005-11-03NaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalse529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6...> 2038.079452NaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOSOESTE POTIGUARPAU DOS FERROSINDUSTRIAS DE TRANSFORMACAO48.00NaNNaNNaNNaNINDUSTRIARNRN5210000.0210000.00.00.0
6ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-07-21NaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseFalseFalse8bf37c178778e537b108e58bf20552abe10c3a7fae129b...5 a 107.27671263.0OUTROSTRANSPORTE TERRESTRENORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISTRANSPORTE ARMAZENAGEM E CORREIO23.001.0NaN1.00.0SERVIÇOMAMA650000.050000.00.00.0
7NaNNaNEMPRESARIO INDIVIDUALALTASERVICOS ADMINISTRATIVOSNaNNaN2018-10-09NaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalse0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d...<= 10.05205540.0OUTROSAGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE...LESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...NaN01.01.0NaN0.0SERVIÇORNRN7NaNNaN0.00.0
8DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00COOPERATIVAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2006-07-27247.88FalseFalseFalseFalseTrueFalseFalseFalseTrueTrueNAOFalseFalseFalseFalseTrueFalse6c45aabb849a760a3a7107c7a61262642f683feb8912a4...10 a 1512.26301436.0ENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DIVERSOSCENTRO AMAZONENSEPARINTINSINDUSTRIAS DE TRANSFORMACAO24.002.0NaN1.00.0INDUSTRIAAMAM8210000.0210000.00.00.0
9DE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00EMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2004-10-301042.85FalseFalseFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalse2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926...15 a 2017.94246652.0OUTROSCOMERCIO VAREJISTAOESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...54.031.0NaN1.00.0COMERCIORNRN9210000.0840000.00.00.0

Last rows

de_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculoididade_emp_catidade_empresa_anosidade_media_sociosnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciaqt_filiaisqt_sociosqt_socios_femininoqt_socios_masculinoqt_socios_pjsetorsg_ufsg_uf_matrizUnnamed_0.1vl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_total_veiculos_leves_grupovl_total_veiculos_pesados_grupo
199990DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMEDIASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOAZUL2013-08-08958.09FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueFalseb3842201eb905c46f0eb4a7b93a7ff34388d3e3f8f83c2...5 a 105.224658NaNOUTROSSERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO...NORTE MARANHENSELENCOIS MARANHENSESATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...23.00NaNNaNNaNNaNSERVIÇOMAMA199990210000.0210000.00.00.0
199991DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAMARELO2005-11-03NaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalse5057d28fa6432ccf08a7d2c7b3b6a069962392b5265531...15 a 2016.55890447.0OUTROSCOMERCIO VAREJISTANORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...24.001.0NaN1.00.0COMERCIOMAMA199991210000.0210000.00.00.0
199992ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALALTASERVICOS DIVERSOSACIMA DE 1 ANOVERDE2008-12-30NaNFalseTrueFalseFalseTrueFalseFalseTrueTrueTrueNAOFalseFalseFalseFalseTrueFalse7665c89ce3d3cd35a8c1f71472da744e78a44115a2a371...5 a 109.832877NaNOUTROSOUTRAS ATIVIDADES DE SERVICOS PESSOAISOESTE POTIGUARSERRA DE SAO MIGUELOUTRAS ATIVIDADES DE SERVICOS23.001.0NaNNaN0.0SERVIÇORNRN19999250000.050000.00.00.0
199993ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALALTASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOVERDE2011-02-25NaNFalseFalseFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalse6b836412910d230bcba8c9d14aa588bf5dfcd7c37859b2...5 a 107.67671240.0OUTROSALIMENTACAOCENTRO AMAZONENSEITACOATIARAALOJAMENTO E ALIMENTACAO25.001.01.0NaN0.0SERVIÇOAMAM19999350000.050000.00.00.0
199994NaNNaNSOCIEDADE EMPRESARIA LIMITADANaNINDUSTRIA DA CONSTRUCAONaNNaN2017-08-03NaNFalseTrueFalseFalseFalseFalseFalseNaNNaNFalseSIMFalseFalseFalseFalseTrueFalseaf91fa4a0cafef1a39e2c79e9eaf0f76344be166cd081e...1 a 51.23561647.0ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISCONSTRUCAONaN42.01.01.00.0CONSTRUÇÃO CIVILMAMA199994NaNNaN3.03.0
199995DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00SOCIEDADE EMPRESARIA LIMITADAMEDIASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOAZUL2013-09-27707.86FalseFalseFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalse47374fcdc31fe94bc9190e9c5d31ee8976307f8082bff1...5 a 105.08767172.0ENTIDADES EMPRESARIAISALIMENTACAONORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISALOJAMENTO E ALIMENTACAO22.002.0NaN1.00.0SERVIÇOMAMA199995247276.8247276.80.00.0
199996DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALMEDIACOMERCIO POR ATACADOACIMA DE 1 ANOAZUL2008-02-151443.43FalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseTrueFalse8a14502b3bfdd18f702df8895a800c4bba3bfd42f10028...10 a 1510.706849NaNOUTROSCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTOR...NaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...24.00NaNNaNNaNNaNCOMERCIORORO199996210000.0210000.00.00.0
199997ATE R$ 81.000,00ATE R$ 81.000,00EMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2013-04-24NaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseNAOFalseFalseFalseFalseTrueFalseba3b7f728587f83023464d54ea06fa5628b3ba8d1aeeb0...5 a 105.51506846.0OUTROSCOMERCIO VAREJISTALESTE MARANHENSECHAPADAS DO ALTO ITAPECURUCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...24.001.0NaN1.00.0COMERCIOMAMA19999750000.050000.00.00.0
199998DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00EMPRESARIO INDIVIDUALBAIXASERVICOS DIVERSOSATE 1 ANOCINZA2017-07-17NaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseeb4ddd433569ecc02bceb40901ba56ba786d48b946e9a4...1 a 51.28219222.0OUTROSREPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...NaNNaNOUTRAS ATIVIDADES DE SERVICOS7.001.0NaN1.00.0SERVIÇORORO199998210000.0210000.00.00.0
199999DE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00SOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2012-05-17439.41FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseFalse099b001d8cdbae0c349cf66c3b0fe1f04c27a06ac58b6d...5 a 106.45205545.0ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSOESTE POTIGUARPAU DOS FERROSCONSTRUCAO48.002.02.0NaN0.0CONSTRUÇÃO CIVILRNRN199999210000.0210000.00.00.0